﻿<?xml version="1.0"?>
<CsvDataLoaderParams xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <TableMetadataEntity>
    <Name>ITSA Awarded Engagements</Name>
    <Category>Government Operations</Category>
    <Description>This dataset provides information about the District's IT Staff Augmentation (ITSA) awarded engagements</Description>
    <Source>Office of Contracting and Procurement (OCP) and Office of the Chief Technology Officer (OCTO)</Source>
    <LastUpdateDate>2009-03-30T00:00:00</LastUpdateDate>
    <MetadataUrl>http://data.octo.dc.gov/Metadata.aspx?id=21</MetadataUrl>
    <EntitySet>ITSAAwardedEngagements</EntitySet>
    <EntityKind>ITSAAwardedEngagement</EntityKind>
  </TableMetadataEntity>
  <ProducerParams>
    <PlacemarkParams>
      <LatitudeProperty>LATITUDE</LatitudeProperty>
      <LongitudeProperty>LONGITUDE</LongitudeProperty>
      <NamePropertyFormatString>Vendor:{0} Engagement Id: {1} Requisition Id: {2}</NamePropertyFormatString>
      <NameProperties>
        <string>VENDOR_NAME</string>
        <string>ENGAGEMENT_ID</string>
        <string>REQUISITION_ID</string>
      </NameProperties>
    </PlacemarkParams>
    <PropertyToTypeMap>
      <REQUISITION_TITLE>string</REQUISITION_TITLE>
      <VENDOR_NAME>string</VENDOR_NAME>
      <ENGAGEMENT_CLIENT_RATE>double</ENGAGEMENT_CLIENT_RATE>
      <ENGAGEMENT_REPORTS_TO>string</ENGAGEMENT_REPORTS_TO>
      <ENGAGEMENT_START_DATE>DateTime</ENGAGEMENT_START_DATE>
      <ENGAGEMENT_ID>int64</ENGAGEMENT_ID>
      <REQUISITION_ID>int64</REQUISITION_ID>
      <VENDOR_ADDRESS_LINE1>string</VENDOR_ADDRESS_LINE1>
      <VENDOR_ADDRESS_LINE2>string</VENDOR_ADDRESS_LINE2>
      <VENDOR_CITY>string</VENDOR_CITY>
      <VENDOR_STATE>string</VENDOR_STATE>
      <VENDOR_ZIPCODE>string</VENDOR_ZIPCODE>
      <LASTMODIFIEDDATE>DateTime</LASTMODIFIEDDATE>
      <CITY>string</CITY>
      <STATE>string</STATE>
      <LATITUDE>double</LATITUDE>
      <LONGITUDE>double</LONGITUDE>
      <WARD>string</WARD>
      <ENGAGEMENT_ASSIGNMENT>string</ENGAGEMENT_ASSIGNMENT>
      <ENGAGEMENT_WORK_LOCATION>string</ENGAGEMENT_WORK_LOCATION>
      <AGENCY>string</AGENCY>
    </PropertyToTypeMap>
  </ProducerParams>
  <ProcessorParams>
    <PartitionKeyPropertyName>VENDOR_NAME</PartitionKeyPropertyName>
    <RowKeyPropertyName>ENGAGEMENT_ID</RowKeyPropertyName>
    <TableMetadataPartitionKeyPropertyName>Name</TableMetadataPartitionKeyPropertyName>
    <TableMetadataRowKeyPropertyName>New.Guid</TableMetadataRowKeyPropertyName>
    <EntityMetadataPartitionKeyPropertyName>EntitySet</EntityMetadataPartitionKeyPropertyName>
    <EntityMetadataRowKeyPropertyName>EntityKind</EntityMetadataRowKeyPropertyName>
  </ProcessorParams>
</CsvDataLoaderParams>